﻿CREATE TABLE [dbo].[TraseeLocatii] (
    [IDClient] INT      CONSTRAINT [DF_TraseeLocatii_IDClient] DEFAULT ((0)) NOT NULL,
    [IDTraseu] INT      CONSTRAINT [DF_TraseeLocatii_IDTraseu] DEFAULT ((0)) NOT NULL,
    [Ordine]   SMALLINT CONSTRAINT [DF_TraseeLocatii_Ordine] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_TraseeLocatii] PRIMARY KEY CLUSTERED ([IDClient] ASC, [IDTraseu] ASC),
    CONSTRAINT [FK_TraseeLocatii_Trasee] FOREIGN KEY ([IDTraseu]) REFERENCES [dbo].[Trasee] ([IDTraseu])
);

